const mongoose = require('mongoose');
const { Schema } = mongoose;
//采购表
const purchaseInfoSchame = new Schema({
  id: String,//采购流水号
  materialId: String,//材料id
  predictPrice: Number,//预估单价
  realPrice: Number,//实际单价
  remark: String,//备注
  predictNum:Number,//预估数量
  realNum: Number,//实际数量
  predictTotal: Number,//预估总金额
  realTotal: Number,//实际总金额
  status: String,//状态
  purchaseDate: Date,//采购时间
  purchaseID: String,//采购单编号
  operator: String//操作人
});

const purchaseInfoModel = mongoose.model('purchase',purchaseInfoSchame);

module.exports = purchaseInfoModel;